Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 8947 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.3 MiB |
| Average record size in memory | 148.0 B |
Variable types
| Numeric | 19 |
|---|
df_index is highly correlated with cust_id | High correlation |
cust_id is highly correlated with df_index | High correlation |
balance is highly correlated with balance_frequency and 4 other fields | High correlation |
balance_frequency is highly correlated with balance and 1 other fields | High correlation |
purchases is highly correlated with oneoff_purchases and 5 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 2 other fields | High correlation |
installments_purchases is highly correlated with purchases and 3 other fields | High correlation |
cash_advance is highly correlated with balance and 2 other fields | High correlation |
purchases_frequency is highly correlated with purchases and 3 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases and 2 other fields | High correlation |
purchases_installments_frequency is highly correlated with purchases and 3 other fields | High correlation |
cash_advance_frequency is highly correlated with balance and 2 other fields | High correlation |
cash_advance_trx is highly correlated with balance and 2 other fields | High correlation |
purchases_trx is highly correlated with purchases and 5 other fields | High correlation |
minimum_payments is highly correlated with balance and 1 other fields | High correlation |
df_index is highly correlated with cust_id | High correlation |
cust_id is highly correlated with df_index | High correlation |
balance is highly correlated with credit_limit | High correlation |
purchases is highly correlated with oneoff_purchases and 3 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 3 other fields | High correlation |
installments_purchases is highly correlated with purchases and 2 other fields | High correlation |
cash_advance is highly correlated with cash_advance_frequency and 1 other fields | High correlation |
purchases_frequency is highly correlated with oneoff_purchases_frequency and 2 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with oneoff_purchases and 2 other fields | High correlation |
purchases_installments_frequency is highly correlated with installments_purchases and 2 other fields | High correlation |
cash_advance_frequency is highly correlated with cash_advance and 1 other fields | High correlation |
cash_advance_trx is highly correlated with cash_advance and 1 other fields | High correlation |
purchases_trx is highly correlated with purchases and 5 other fields | High correlation |
credit_limit is highly correlated with balance | High correlation |
payments is highly correlated with purchases and 1 other fields | High correlation |
df_index is highly correlated with cust_id | High correlation |
cust_id is highly correlated with df_index | High correlation |
balance is highly correlated with minimum_payments | High correlation |
purchases is highly correlated with oneoff_purchases and 4 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 1 other fields | High correlation |
installments_purchases is highly correlated with purchases and 3 other fields | High correlation |
cash_advance is highly correlated with cash_advance_frequency and 1 other fields | High correlation |
purchases_frequency is highly correlated with purchases and 3 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases and 1 other fields | High correlation |
purchases_installments_frequency is highly correlated with installments_purchases and 2 other fields | High correlation |
cash_advance_frequency is highly correlated with cash_advance and 1 other fields | High correlation |
cash_advance_trx is highly correlated with cash_advance and 1 other fields | High correlation |
purchases_trx is highly correlated with purchases and 3 other fields | High correlation |
minimum_payments is highly correlated with balance | High correlation |
df_index is highly correlated with cust_id | High correlation |
cust_id is highly correlated with df_index | High correlation |
balance is highly correlated with credit_limit | High correlation |
purchases is highly correlated with oneoff_purchases and 4 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 2 other fields | High correlation |
installments_purchases is highly correlated with purchases and 1 other fields | High correlation |
cash_advance is highly correlated with cash_advance_trx and 1 other fields | High correlation |
purchases_frequency is highly correlated with oneoff_purchases_frequency and 1 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases_frequency | High correlation |
purchases_installments_frequency is highly correlated with purchases_frequency | High correlation |
cash_advance_frequency is highly correlated with cash_advance_trx | High correlation |
cash_advance_trx is highly correlated with cash_advance and 1 other fields | High correlation |
purchases_trx is highly correlated with purchases and 3 other fields | High correlation |
credit_limit is highly correlated with balance and 2 other fields | High correlation |
payments is highly correlated with purchases and 4 other fields | High correlation |
df_index is uniformly distributed | Uniform |
cust_id is uniformly distributed | Uniform |
df_index has unique values | Unique |
cust_id has unique values | Unique |
purchases has 2044 (22.8%) zeros | Zeros |
oneoff_purchases has 4300 (48.1%) zeros | Zeros |
installments_purchases has 3915 (43.8%) zeros | Zeros |
cash_advance has 4625 (51.7%) zeros | Zeros |
purchases_frequency has 2043 (22.8%) zeros | Zeros |
oneoff_purchases_frequency has 4300 (48.1%) zeros | Zeros |
purchases_installments_frequency has 3914 (43.7%) zeros | Zeros |
cash_advance_frequency has 4625 (51.7%) zeros | Zeros |
cash_advance_trx has 4625 (51.7%) zeros | Zeros |
purchases_trx has 2041 (22.8%) zeros | Zeros |
payments has 240 (2.7%) zeros | Zeros |
minimum_payments has 313 (3.5%) zeros | Zeros |
prc_full_payment has 5902 (66.0%) zeros | Zeros |
Reproduction
| Analysis started | 2021-11-14 11:02:02.034269 |
|---|---|
| Analysis finished | 2021-11-14 11:03:16.487328 |
| Duration | 1 minute and 14.45 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
df_index
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 8947 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4474.933497 |
| Minimum | 0 |
|---|---|
| Maximum | 8949 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 447.3 |
| Q1 | 2237.5 |
| median | 4475 |
| Q3 | 6712.5 |
| 95-th percentile | 8501.7 |
| Maximum | 8949 |
| Range | 8949 |
| Interquartile range (IQR) | 4475 |
Descriptive statistics
| Standard deviation | 2584.006209 |
|---|---|
| Coefficient of variation (CV) | 0.5774401364 |
| Kurtosis | -1.20021705 |
| Mean | 4474.933497 |
| Median Absolute Deviation (MAD) | 2238 |
| Skewness | -0.0003210456529 |
| Sum | 40037230 |
| Variance | 6677088.088 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 2652 | 1 | < 0.1% |
| 8785 | 1 | < 0.1% |
| 2644 | 1 | < 0.1% |
| 597 | 1 | < 0.1% |
| 6742 | 1 | < 0.1% |
| 4695 | 1 | < 0.1% |
| 8793 | 1 | < 0.1% |
| 605 | 1 | < 0.1% |
| 8809 | 1 | < 0.1% |
| Other values (8937) | 8937 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 8949 | 1 | |
| 8948 | 1 | |
| 8947 | 1 | |
| 8946 | 1 | |
| 8945 | 1 | |
| 8944 | 1 | |
| 8943 | 1 | |
| 8942 | 1 | |
| 8941 | 1 | |
| 8940 | 1 |
cust_id
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 8947 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14600.48564 |
| Minimum | 10001 |
|---|---|
| Maximum | 19190 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 35.1 KiB |
Quantile statistics
| Minimum | 10001 |
|---|---|
| 5-th percentile | 10463.9 |
| Q1 | 12307.5 |
| median | 14599 |
| Q3 | 16900.5 |
| 95-th percentile | 18732.7 |
| Maximum | 19190 |
| Range | 9189 |
| Interquartile range (IQR) | 4593 |
Descriptive statistics
| Standard deviation | 2651.531144 |
|---|---|
| Coefficient of variation (CV) | 0.1816056815 |
| Kurtosis | -1.199476032 |
| Mean | 14600.48564 |
| Median Absolute Deviation (MAD) | 2297 |
| Skewness | -0.001149197228 |
| Sum | 130630545 |
| Variance | 7030617.409 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 16384 | 1 | < 0.1% |
| 14922 | 1 | < 0.1% |
| 10816 | 1 | < 0.1% |
| 14914 | 1 | < 0.1% |
| 12867 | 1 | < 0.1% |
| 19012 | 1 | < 0.1% |
| 16965 | 1 | < 0.1% |
| 10824 | 1 | < 0.1% |
| 12875 | 1 | < 0.1% |
| 10840 | 1 | < 0.1% |
| Other values (8937) | 8937 |
| Value | Count | Frequency (%) |
| 10001 | 1 | |
| 10002 | 1 | |
| 10003 | 1 | |
| 10004 | 1 | |
| 10005 | 1 | |
| 10006 | 1 | |
| 10007 | 1 | |
| 10008 | 1 | |
| 10009 | 1 | |
| 10010 | 1 |
| Value | Count | Frequency (%) |
| 19190 | 1 | |
| 19189 | 1 | |
| 19188 | 1 | |
| 19187 | 1 | |
| 19186 | 1 | |
| 19185 | 1 | |
| 19184 | 1 | |
| 19183 | 1 | |
| 19182 | 1 | |
| 19181 | 1 |
| Distinct | 8868 |
|---|---|
| Distinct (%) | 99.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1564.990615 |
| Minimum | 0 |
|---|---|
| Maximum | 19043.13856 |
| Zeros | 80 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8.8261286 |
| Q1 | 128.4324965 |
| median | 874.203747 |
| Q3 | 2054.678104 |
| 95-th percentile | 5909.910049 |
| Maximum | 19043.13856 |
| Range | 19043.13856 |
| Interquartile range (IQR) | 1926.245608 |
Descriptive statistics
| Standard deviation | 2081.690135 |
|---|---|
| Coefficient of variation (CV) | 1.330161418 |
| Kurtosis | 7.672612838 |
| Mean | 1564.990615 |
| Median Absolute Deviation (MAD) | 800.327269 |
| Skewness | 2.393034871 |
| Sum | 14001971.03 |
| Variance | 4333433.82 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 80 | 0.9% |
| 449.026889 | 1 | < 0.1% |
| 34.750769 | 1 | < 0.1% |
| 2643.343414 | 1 | < 0.1% |
| 6366.085376 | 1 | < 0.1% |
| 1112.915657 | 1 | < 0.1% |
| 2545.614986 | 1 | < 0.1% |
| 74.825456 | 1 | < 0.1% |
| 7656.390367 | 1 | < 0.1% |
| 177.696201 | 1 | < 0.1% |
| Other values (8858) | 8858 |
| Value | Count | Frequency (%) |
| 0 | 80 | |
| 0.000199 | 1 | < 0.1% |
| 0.001146 | 1 | < 0.1% |
| 0.001214 | 1 | < 0.1% |
| 0.001289 | 1 | < 0.1% |
| 0.004816 | 1 | < 0.1% |
| 0.006651 | 1 | < 0.1% |
| 0.009684 | 1 | < 0.1% |
| 0.01968 | 1 | < 0.1% |
| 0.021102 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 19043.13856 | 1 | |
| 18495.55855 | 1 | |
| 16304.88925 | 1 | |
| 16259.44857 | 1 | |
| 16115.5964 | 1 | |
| 15532.33972 | 1 | |
| 15258.2259 | 1 | |
| 15244.74865 | 1 | |
| 15155.53286 | 1 | |
| 14581.45914 | 1 |
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8773718254 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 80 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.272727 |
| Q1 | 0.888889 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.111111 |
Descriptive statistics
| Standard deviation | 0.2368117501 |
|---|---|
| Coefficient of variation (CV) | 0.2699103655 |
| Kurtosis | 3.101481885 |
| Mean | 0.8773718254 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.025110954 |
| Sum | 7849.845722 |
| Variance | 0.05607980499 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 6210 | |
| 0.909091 | 410 | 4.6% |
| 0.818182 | 278 | 3.1% |
| 0.727273 | 223 | 2.5% |
| 0.545455 | 219 | 2.4% |
| 0.636364 | 209 | 2.3% |
| 0.454545 | 171 | 1.9% |
| 0.363636 | 170 | 1.9% |
| 0.272727 | 150 | 1.7% |
| 0.181818 | 146 | 1.6% |
| Other values (33) | 761 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 80 | |
| 0.090909 | 67 | |
| 0.1 | 8 | 0.1% |
| 0.111111 | 5 | 0.1% |
| 0.125 | 9 | 0.1% |
| 0.142857 | 7 | 0.1% |
| 0.166667 | 7 | 0.1% |
| 0.181818 | 146 | |
| 0.2 | 9 | 0.1% |
| 0.222222 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 6210 | |
| 0.909091 | 410 | 4.6% |
| 0.9 | 55 | 0.6% |
| 0.888889 | 53 | 0.6% |
| 0.875 | 57 | 0.6% |
| 0.857143 | 51 | 0.6% |
| 0.833333 | 60 | 0.7% |
| 0.818182 | 278 | 3.1% |
| 0.8 | 20 | 0.2% |
| 0.777778 | 22 | 0.2% |
purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 6200 |
|---|---|
| Distinct (%) | 69.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1003.453347 |
| Minimum | 0 |
|---|---|
| Maximum | 49039.57 |
| Zeros | 2044 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 39.69 |
| median | 361.49 |
| Q3 | 1110.295 |
| 95-th percentile | 3999.053 |
| Maximum | 49039.57 |
| Range | 49039.57 |
| Interquartile range (IQR) | 1070.605 |
Descriptive statistics
| Standard deviation | 2136.943593 |
|---|---|
| Coefficient of variation (CV) | 2.129589381 |
| Kurtosis | 111.3572279 |
| Mean | 1003.453347 |
| Median Absolute Deviation (MAD) | 361.49 |
| Skewness | 8.143140046 |
| Sum | 8977897.1 |
| Variance | 4566527.92 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2044 | 22.8% |
| 45.65 | 27 | 0.3% |
| 150 | 16 | 0.2% |
| 60 | 16 | 0.2% |
| 300 | 13 | 0.1% |
| 200 | 13 | 0.1% |
| 100 | 13 | 0.1% |
| 450 | 12 | 0.1% |
| 50 | 10 | 0.1% |
| 120 | 10 | 0.1% |
| Other values (6190) | 6773 |
| Value | Count | Frequency (%) |
| 0 | 2044 | |
| 0.01 | 4 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 1.4 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4.44 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| 4.99 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49039.57 | 1 | |
| 41050.4 | 1 | |
| 40040.71 | 1 | |
| 38902.71 | 1 | |
| 35131.16 | 1 | |
| 32539.78 | 1 | |
| 31299.35 | 1 | |
| 27957.68 | 1 | |
| 27790.42 | 1 | |
| 26784.62 | 1 |
oneoff_purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 4013 |
|---|---|
| Distinct (%) | 44.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 592.6359931 |
| Minimum | 0 |
|---|---|
| Maximum | 40761.25 |
| Zeros | 4300 |
| Zeros (%) | 48.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 38.4 |
| Q3 | 577.945 |
| 95-th percentile | 2672.396 |
| Maximum | 40761.25 |
| Range | 40761.25 |
| Interquartile range (IQR) | 577.945 |
Descriptive statistics
| Standard deviation | 1660.130761 |
|---|---|
| Coefficient of variation (CV) | 2.801265499 |
| Kurtosis | 164.1410243 |
| Mean | 592.6359931 |
| Median Absolute Deviation (MAD) | 38.4 |
| Skewness | 10.04369943 |
| Sum | 5302314.23 |
| Variance | 2756034.144 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4300 | |
| 45.65 | 46 | 0.5% |
| 50 | 17 | 0.2% |
| 200 | 15 | 0.2% |
| 60 | 13 | 0.1% |
| 100 | 13 | 0.1% |
| 1000 | 12 | 0.1% |
| 150 | 12 | 0.1% |
| 70 | 12 | 0.1% |
| 250 | 11 | 0.1% |
| Other values (4003) | 4496 |
| Value | Count | Frequency (%) |
| 0 | 4300 | |
| 0.01 | 7 | 0.1% |
| 0.02 | 2 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 1 | 4 | < 0.1% |
| 1.4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4.99 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40761.25 | 1 | |
| 40624.06 | 1 | |
| 34087.73 | 1 | |
| 33803.84 | 1 | |
| 26547.43 | 1 | |
| 26514.32 | 1 | |
| 25122.77 | 1 | |
| 24543.52 | 1 | |
| 23032.97 | 1 | |
| 22257.39 | 1 |
installments_purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 4450 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 411.1151783 |
| Minimum | 0 |
|---|---|
| Maximum | 22500 |
| Zeros | 3915 |
| Zeros (%) | 43.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 89 |
| Q3 | 468.625 |
| 95-th percentile | 1751.085 |
| Maximum | 22500 |
| Range | 22500 |
| Interquartile range (IQR) | 468.625 |
Descriptive statistics
| Standard deviation | 904.4714553 |
|---|---|
| Coefficient of variation (CV) | 2.200043937 |
| Kurtosis | 96.54832487 |
| Mean | 411.1151783 |
| Median Absolute Deviation (MAD) | 89 |
| Skewness | 7.298192602 |
| Sum | 3678247.5 |
| Variance | 818068.6135 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3915 | |
| 100 | 14 | 0.2% |
| 300 | 14 | 0.2% |
| 200 | 14 | 0.2% |
| 150 | 12 | 0.1% |
| 125 | 11 | 0.1% |
| 75 | 9 | 0.1% |
| 450 | 8 | 0.1% |
| 350 | 8 | 0.1% |
| 225 | 8 | 0.1% |
| Other values (4440) | 4934 |
| Value | Count | Frequency (%) |
| 0 | 3915 | |
| 1.95 | 1 | < 0.1% |
| 4.44 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| 6.33 | 1 | < 0.1% |
| 7.26 | 1 | < 0.1% |
| 7.67 | 1 | < 0.1% |
| 9.28 | 1 | < 0.1% |
| 9.58 | 1 | < 0.1% |
| 9.65 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 22500 | 1 | |
| 15497.19 | 1 | |
| 14686.1 | 1 | |
| 13184.43 | 1 | |
| 12738.47 | 1 | |
| 12560.85 | 1 | |
| 12541 | 1 | |
| 12375 | 1 | |
| 12235.05 | 1 | |
| 12128.94 | 1 |
cash_advance
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 4323 |
|---|---|
| Distinct (%) | 48.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 979.1993357 |
| Minimum | 0 |
|---|---|
| Maximum | 47137.21176 |
| Zeros | 4625 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1113.896495 |
| 95-th percentile | 4649.343813 |
| Maximum | 47137.21176 |
| Range | 47137.21176 |
| Interquartile range (IQR) | 1113.896495 |
Descriptive statistics
| Standard deviation | 2097.438861 |
|---|---|
| Coefficient of variation (CV) | 2.141993754 |
| Kurtosis | 52.88562188 |
| Mean | 979.1993357 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.165874072 |
| Sum | 8760896.457 |
| Variance | 4399249.775 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4625 | |
| 808.489505 | 1 | < 0.1% |
| 2684.507978 | 1 | < 0.1% |
| 9894.067335 | 1 | < 0.1% |
| 5409.095889 | 1 | < 0.1% |
| 724.694411 | 1 | < 0.1% |
| 1420.758241 | 1 | < 0.1% |
| 2081.583331 | 1 | < 0.1% |
| 2970.97936 | 1 | < 0.1% |
| 4353.620039 | 1 | < 0.1% |
| Other values (4313) | 4313 |
| Value | Count | Frequency (%) |
| 0 | 4625 | |
| 14.222216 | 1 | < 0.1% |
| 18.042768 | 1 | < 0.1% |
| 18.117967 | 1 | < 0.1% |
| 18.123413 | 1 | < 0.1% |
| 18.126683 | 1 | < 0.1% |
| 18.149946 | 1 | < 0.1% |
| 18.204577 | 1 | < 0.1% |
| 18.240626 | 1 | < 0.1% |
| 18.280043 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 47137.21176 | 1 | |
| 29282.10915 | 1 | |
| 27296.48576 | 1 | |
| 26268.69989 | 1 | |
| 26194.04954 | 1 | |
| 23130.82106 | 1 | |
| 22665.7785 | 1 | |
| 21943.84942 | 1 | |
| 20712.67008 | 1 | |
| 20277.33112 | 1 |
purchases_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4903845694 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 2043 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.083333 |
| median | 0.5 |
| Q3 | 0.916667 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.833334 |
Descriptive statistics
| Standard deviation | 0.4013557382 |
|---|---|
| Coefficient of variation (CV) | 0.8184509938 |
| Kurtosis | -1.638518049 |
| Mean | 0.4903845694 |
| Median Absolute Deviation (MAD) | 0.416667 |
| Skewness | 0.05994110161 |
| Sum | 4387.470742 |
| Variance | 0.1610864285 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2177 | |
| 0 | 2043 | |
| 0.083333 | 675 | 7.5% |
| 0.916667 | 396 | 4.4% |
| 0.5 | 395 | 4.4% |
| 0.166667 | 392 | 4.4% |
| 0.833333 | 373 | 4.2% |
| 0.333333 | 367 | 4.1% |
| 0.25 | 345 | 3.9% |
| 0.583333 | 316 | 3.5% |
| Other values (37) | 1468 |
| Value | Count | Frequency (%) |
| 0 | 2043 | |
| 0.083333 | 675 | 7.5% |
| 0.090909 | 43 | 0.5% |
| 0.1 | 27 | 0.3% |
| 0.111111 | 18 | 0.2% |
| 0.125 | 32 | 0.4% |
| 0.142857 | 26 | 0.3% |
| 0.166667 | 392 | 4.4% |
| 0.181818 | 16 | 0.2% |
| 0.2 | 19 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 2177 | |
| 0.916667 | 396 | 4.4% |
| 0.909091 | 28 | 0.3% |
| 0.9 | 24 | 0.3% |
| 0.888889 | 18 | 0.2% |
| 0.875 | 26 | 0.3% |
| 0.857143 | 25 | 0.3% |
| 0.833333 | 373 | 4.2% |
| 0.818182 | 21 | 0.2% |
| 0.8 | 9 | 0.1% |
oneoff_purchases_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2025162552 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 4300 |
| Zeros (%) | 48.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.083333 |
| Q3 | 0.3 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.3 |
Descriptive statistics
| Standard deviation | 0.298368064 |
|---|---|
| Coefficient of variation (CV) | 1.473304273 |
| Kurtosis | 1.160199624 |
| Mean | 0.2025162552 |
| Median Absolute Deviation (MAD) | 0.083333 |
| Skewness | 1.535121607 |
| Sum | 1811.912935 |
| Variance | 0.08902350164 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4300 | |
| 0.083333 | 1103 | 12.3% |
| 0.166667 | 592 | 6.6% |
| 1 | 481 | 5.4% |
| 0.25 | 418 | 4.7% |
| 0.333333 | 355 | 4.0% |
| 0.416667 | 244 | 2.7% |
| 0.5 | 235 | 2.6% |
| 0.583333 | 197 | 2.2% |
| 0.666667 | 167 | 1.9% |
| Other values (37) | 855 | 9.6% |
| Value | Count | Frequency (%) |
| 0 | 4300 | |
| 0.083333 | 1103 | 12.3% |
| 0.090909 | 56 | 0.6% |
| 0.1 | 39 | 0.4% |
| 0.111111 | 26 | 0.3% |
| 0.125 | 41 | 0.5% |
| 0.142857 | 37 | 0.4% |
| 0.166667 | 592 | 6.6% |
| 0.181818 | 34 | 0.4% |
| 0.2 | 27 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 481 | |
| 0.916667 | 151 | 1.7% |
| 0.909091 | 4 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.888889 | 2 | < 0.1% |
| 0.875 | 6 | 0.1% |
| 0.857143 | 1 | < 0.1% |
| 0.833333 | 120 | 1.3% |
| 0.818182 | 10 | 0.1% |
| 0.8 | 4 | < 0.1% |
purchases_installments_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3644384569 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 3914 |
| Zeros (%) | 43.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.166667 |
| Q3 | 0.75 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.3974278275 |
|---|---|
| Coefficient of variation (CV) | 1.090521101 |
| Kurtosis | -1.398617287 |
| Mean | 0.3644384569 |
| Median Absolute Deviation (MAD) | 0.166667 |
| Skewness | 0.5091087699 |
| Sum | 3260.630874 |
| Variance | 0.157948878 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3914 | |
| 1 | 1330 | 14.9% |
| 0.416667 | 388 | 4.3% |
| 0.916667 | 345 | 3.9% |
| 0.833333 | 311 | 3.5% |
| 0.5 | 310 | 3.5% |
| 0.166667 | 305 | 3.4% |
| 0.666667 | 292 | 3.3% |
| 0.75 | 291 | 3.3% |
| 0.083333 | 274 | 3.1% |
| Other values (37) | 1187 | 13.3% |
| Value | Count | Frequency (%) |
| 0 | 3914 | |
| 0.083333 | 274 | 3.1% |
| 0.090909 | 12 | 0.1% |
| 0.1 | 6 | 0.1% |
| 0.111111 | 9 | 0.1% |
| 0.125 | 5 | 0.1% |
| 0.142857 | 6 | 0.1% |
| 0.166667 | 305 | 3.4% |
| 0.181818 | 14 | 0.2% |
| 0.2 | 9 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1330 | |
| 0.916667 | 345 | 3.9% |
| 0.909091 | 25 | 0.3% |
| 0.9 | 19 | 0.2% |
| 0.888889 | 28 | 0.3% |
| 0.875 | 28 | 0.3% |
| 0.857143 | 30 | 0.3% |
| 0.833333 | 311 | 3.5% |
| 0.818182 | 21 | 0.2% |
| 0.8 | 18 | 0.2% |
cash_advance_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 54 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1351895153 |
| Minimum | 0 |
|---|---|
| Maximum | 1.5 |
| Zeros | 4625 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.222222 |
| 95-th percentile | 0.583333 |
| Maximum | 1.5 |
| Range | 1.5 |
| Interquartile range (IQR) | 0.222222 |
Descriptive statistics
| Standard deviation | 0.2001396345 |
|---|---|
| Coefficient of variation (CV) | 1.480437548 |
| Kurtosis | 3.33282257 |
| Mean | 0.1351895153 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.828223239 |
| Sum | 1209.540593 |
| Variance | 0.04005587331 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4625 | |
| 0.083333 | 1021 | 11.4% |
| 0.166667 | 759 | 8.5% |
| 0.25 | 578 | 6.5% |
| 0.333333 | 439 | 4.9% |
| 0.416667 | 273 | 3.1% |
| 0.5 | 215 | 2.4% |
| 0.583333 | 142 | 1.6% |
| 0.666667 | 125 | 1.4% |
| 0.090909 | 70 | 0.8% |
| Other values (44) | 700 | 7.8% |
| Value | Count | Frequency (%) |
| 0 | 4625 | |
| 0.083333 | 1021 | 11.4% |
| 0.090909 | 70 | 0.8% |
| 0.1 | 39 | 0.4% |
| 0.111111 | 29 | 0.3% |
| 0.125 | 47 | 0.5% |
| 0.142857 | 49 | 0.5% |
| 0.166667 | 759 | 8.5% |
| 0.181818 | 42 | 0.5% |
| 0.2 | 21 | 0.2% |
| Value | Count | Frequency (%) |
| 1.5 | 1 | < 0.1% |
| 1.25 | 1 | < 0.1% |
| 1.166667 | 2 | < 0.1% |
| 1.142857 | 1 | < 0.1% |
| 1.125 | 1 | < 0.1% |
| 1.1 | 1 | < 0.1% |
| 1.090909 | 1 | < 0.1% |
| 1 | 25 | |
| 0.916667 | 27 | |
| 0.909091 | 3 | < 0.1% |
cash_advance_trx
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 65 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.249916173 |
| Minimum | 0 |
|---|---|
| Maximum | 123 |
| Zeros | 4625 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4 |
| 95-th percentile | 15 |
| Maximum | 123 |
| Range | 123 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 6.825531587 |
|---|---|
| Coefficient of variation (CV) | 2.100217736 |
| Kurtosis | 61.63135721 |
| Mean | 3.249916173 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.720548968 |
| Sum | 29077 |
| Variance | 46.58788145 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4625 | |
| 1 | 887 | 9.9% |
| 2 | 620 | 6.9% |
| 3 | 436 | 4.9% |
| 4 | 384 | 4.3% |
| 5 | 308 | 3.4% |
| 6 | 246 | 2.7% |
| 7 | 205 | 2.3% |
| 8 | 171 | 1.9% |
| 10 | 150 | 1.7% |
| Other values (55) | 915 | 10.2% |
| Value | Count | Frequency (%) |
| 0 | 4625 | |
| 1 | 887 | 9.9% |
| 2 | 620 | 6.9% |
| 3 | 436 | 4.9% |
| 4 | 384 | 4.3% |
| 5 | 308 | 3.4% |
| 6 | 246 | 2.7% |
| 7 | 205 | 2.3% |
| 8 | 171 | 1.9% |
| 9 | 111 | 1.2% |
| Value | Count | Frequency (%) |
| 123 | 3 | |
| 110 | 1 | < 0.1% |
| 107 | 1 | < 0.1% |
| 93 | 1 | < 0.1% |
| 80 | 1 | < 0.1% |
| 71 | 1 | < 0.1% |
| 69 | 1 | < 0.1% |
| 63 | 1 | < 0.1% |
| 62 | 3 | |
| 61 | 1 | < 0.1% |
purchases_trx
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 173 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.71476473 |
| Minimum | 0 |
|---|---|
| Maximum | 358 |
| Zeros | 2041 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 17 |
| 95-th percentile | 57 |
| Maximum | 358 |
| Range | 358 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 24.86035688 |
|---|---|
| Coefficient of variation (CV) | 1.689483817 |
| Kurtosis | 34.78559614 |
| Mean | 14.71476473 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 4.630169188 |
| Sum | 131653 |
| Variance | 618.037344 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2041 | |
| 1 | 667 | 7.5% |
| 12 | 570 | 6.4% |
| 2 | 379 | 4.2% |
| 6 | 352 | 3.9% |
| 3 | 314 | 3.5% |
| 4 | 285 | 3.2% |
| 7 | 275 | 3.1% |
| 8 | 267 | 3.0% |
| 5 | 267 | 3.0% |
| Other values (163) | 3530 |
| Value | Count | Frequency (%) |
| 0 | 2041 | |
| 1 | 667 | 7.5% |
| 2 | 379 | 4.2% |
| 3 | 314 | 3.5% |
| 4 | 285 | 3.2% |
| 5 | 267 | 3.0% |
| 6 | 352 | 3.9% |
| 7 | 275 | 3.1% |
| 8 | 267 | 3.0% |
| 9 | 248 | 2.8% |
| Value | Count | Frequency (%) |
| 358 | 1 | |
| 347 | 1 | |
| 344 | 1 | |
| 309 | 1 | |
| 308 | 1 | |
| 298 | 1 | |
| 274 | 1 | |
| 273 | 1 | |
| 254 | 1 | |
| 248 | 2 |
| Distinct | 205 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4493.447874 |
| Minimum | 50 |
|---|---|
| Maximum | 30000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1600 |
| median | 3000 |
| Q3 | 6500 |
| 95-th percentile | 12000 |
| Maximum | 30000 |
| Range | 29950 |
| Interquartile range (IQR) | 4900 |
Descriptive statistics
| Standard deviation | 3637.91594 |
|---|---|
| Coefficient of variation (CV) | 0.8096045713 |
| Kurtosis | 2.8403546 |
| Mean | 4493.447874 |
| Median Absolute Deviation (MAD) | 1800 |
| Skewness | 1.522669225 |
| Sum | 40202878.13 |
| Variance | 13234432.38 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3000 | 783 | 8.8% |
| 1500 | 722 | 8.1% |
| 1200 | 621 | 6.9% |
| 1000 | 613 | 6.9% |
| 2500 | 612 | 6.8% |
| 4000 | 506 | 5.7% |
| 6000 | 463 | 5.2% |
| 5000 | 389 | 4.3% |
| 2000 | 371 | 4.1% |
| 7500 | 277 | 3.1% |
| Other values (195) | 3590 |
| Value | Count | Frequency (%) |
| 50 | 2 | < 0.1% |
| 150 | 5 | 0.1% |
| 200 | 3 | < 0.1% |
| 300 | 14 | 0.2% |
| 400 | 3 | < 0.1% |
| 450 | 6 | 0.1% |
| 500 | 121 | |
| 600 | 21 | 0.2% |
| 650 | 1 | < 0.1% |
| 700 | 20 | 0.2% |
| Value | Count | Frequency (%) |
| 30000 | 2 | < 0.1% |
| 28000 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 23000 | 2 | < 0.1% |
| 22500 | 1 | < 0.1% |
| 22000 | 1 | < 0.1% |
| 21500 | 2 | < 0.1% |
| 21000 | 2 | < 0.1% |
| 20500 | 1 | < 0.1% |
| 20000 | 10 |
| Distinct | 8708 |
|---|---|
| Distinct (%) | 97.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1730.387793 |
| Minimum | 0 |
|---|---|
| Maximum | 50721.48336 |
| Zeros | 240 |
| Zeros (%) | 2.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 89.9665123 |
| Q1 | 383.278394 |
| median | 857.062706 |
| Q3 | 1900.989314 |
| 95-th percentile | 6075.3567 |
| Maximum | 50721.48336 |
| Range | 50721.48336 |
| Interquartile range (IQR) | 1517.71092 |
Descriptive statistics
| Standard deviation | 2881.104237 |
|---|---|
| Coefficient of variation (CV) | 1.665004948 |
| Kurtosis | 55.04500104 |
| Mean | 1730.387793 |
| Median Absolute Deviation (MAD) | 581.375627 |
| Skewness | 5.904150961 |
| Sum | 15481779.58 |
| Variance | 8300761.627 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 240 | 2.7% |
| 414.218007 | 1 | < 0.1% |
| 2147.890523 | 1 | < 0.1% |
| 996.350965 | 1 | < 0.1% |
| 797.029627 | 1 | < 0.1% |
| 1212.054219 | 1 | < 0.1% |
| 1664.863771 | 1 | < 0.1% |
| 2857.881585 | 1 | < 0.1% |
| 3530.131795 | 1 | < 0.1% |
| 732.01795 | 1 | < 0.1% |
| Other values (8698) | 8698 |
| Value | Count | Frequency (%) |
| 0 | 240 | |
| 0.049513 | 1 | < 0.1% |
| 0.056466 | 1 | < 0.1% |
| 2.389583 | 1 | < 0.1% |
| 3.500505 | 1 | < 0.1% |
| 4.523555 | 1 | < 0.1% |
| 4.841543 | 1 | < 0.1% |
| 5.070726 | 1 | < 0.1% |
| 9.040017 | 1 | < 0.1% |
| 9.533313 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 50721.48336 | 1 | |
| 46930.59824 | 1 | |
| 40627.59524 | 1 | |
| 39461.9658 | 1 | |
| 39048.59762 | 1 | |
| 36066.75068 | 1 | |
| 35843.62593 | 1 | |
| 34107.07499 | 1 | |
| 33994.72785 | 1 | |
| 33486.31044 | 1 |
| Distinct | 8634 |
|---|---|
| Distinct (%) | 96.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 834.1168765 |
| Minimum | 0 |
|---|---|
| Maximum | 76406.20752 |
| Zeros | 313 |
| Zeros (%) | 3.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 29.7597689 |
| Q1 | 163.036918 |
| median | 289.686899 |
| Q3 | 788.7053925 |
| 95-th percentile | 2720.450767 |
| Maximum | 76406.20752 |
| Range | 76406.20752 |
| Interquartile range (IQR) | 625.6684745 |
Descriptive statistics
| Standard deviation | 2336.35461 |
|---|---|
| Coefficient of variation (CV) | 2.800991894 |
| Kurtosis | 292.2692525 |
| Mean | 834.1168765 |
| Median Absolute Deviation (MAD) | 188.773897 |
| Skewness | 13.80642927 |
| Sum | 7462843.694 |
| Variance | 5458552.862 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 313 | 3.5% |
| 299.351881 | 2 | < 0.1% |
| 169.574114 | 1 | < 0.1% |
| 210.156238 | 1 | < 0.1% |
| 200.106261 | 1 | < 0.1% |
| 25697.63772 | 1 | < 0.1% |
| 427.14706 | 1 | < 0.1% |
| 227.726516 | 1 | < 0.1% |
| 438.190574 | 1 | < 0.1% |
| 179.412493 | 1 | < 0.1% |
| Other values (8624) | 8624 |
| Value | Count | Frequency (%) |
| 0 | 313 | |
| 0.019163 | 1 | < 0.1% |
| 0.037744 | 1 | < 0.1% |
| 0.05588 | 1 | < 0.1% |
| 0.059481 | 1 | < 0.1% |
| 0.117036 | 1 | < 0.1% |
| 0.261984 | 1 | < 0.1% |
| 0.311953 | 1 | < 0.1% |
| 0.319475 | 1 | < 0.1% |
| 1.113027 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 76406.20752 | 1 | |
| 61031.6186 | 1 | |
| 56370.04117 | 1 | |
| 50260.75947 | 1 | |
| 43132.72823 | 1 | |
| 42629.55117 | 1 | |
| 38512.12477 | 1 | |
| 31871.36379 | 1 | |
| 30528.4324 | 1 | |
| 29019.80288 | 1 |
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1536730492 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 5902 |
| Zeros (%) | 66.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.142857 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.142857 |
Descriptive statistics
| Standard deviation | 0.2925146442 |
|---|---|
| Coefficient of variation (CV) | 1.903486953 |
| Kurtosis | 2.433931941 |
| Mean | 0.1536730492 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.943395288 |
| Sum | 1374.912771 |
| Variance | 0.08556481706 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5902 | |
| 1 | 488 | 5.5% |
| 0.083333 | 426 | 4.8% |
| 0.166667 | 166 | 1.9% |
| 0.25 | 156 | 1.7% |
| 0.5 | 155 | 1.7% |
| 0.090909 | 153 | 1.7% |
| 0.333333 | 133 | 1.5% |
| 0.1 | 94 | 1.1% |
| 0.2 | 83 | 0.9% |
| Other values (37) | 1191 | 13.3% |
| Value | Count | Frequency (%) |
| 0 | 5902 | |
| 0.083333 | 426 | 4.8% |
| 0.090909 | 153 | 1.7% |
| 0.1 | 94 | 1.1% |
| 0.111111 | 61 | 0.7% |
| 0.125 | 52 | 0.6% |
| 0.142857 | 54 | 0.6% |
| 0.166667 | 166 | 1.9% |
| 0.181818 | 75 | 0.8% |
| 0.2 | 83 | 0.9% |
| Value | Count | Frequency (%) |
| 1 | 488 | |
| 0.916667 | 77 | 0.9% |
| 0.909091 | 19 | 0.2% |
| 0.9 | 16 | 0.2% |
| 0.888889 | 12 | 0.1% |
| 0.875 | 18 | 0.2% |
| 0.857143 | 12 | 0.1% |
| 0.833333 | 63 | 0.7% |
| 0.818182 | 17 | 0.2% |
| 0.8 | 33 | 0.4% |
tenure
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.51715659 |
| Minimum | 6 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 12 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.338525958 |
|---|---|
| Coefficient of variation (CV) | 0.1162201753 |
| Kurtosis | 7.690743015 |
| Mean | 11.51715659 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.942369614 |
| Sum | 103044 |
| Variance | 1.79165174 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 7581 | |
| 11 | 365 | 4.1% |
| 10 | 236 | 2.6% |
| 6 | 204 | 2.3% |
| 8 | 196 | 2.2% |
| 7 | 190 | 2.1% |
| 9 | 175 | 2.0% |
| Value | Count | Frequency (%) |
| 6 | 204 | 2.3% |
| 7 | 190 | 2.1% |
| 8 | 196 | 2.2% |
| 9 | 175 | 2.0% |
| 10 | 236 | 2.6% |
| 11 | 365 | 4.1% |
| 12 | 7581 |
| Value | Count | Frequency (%) |
| 12 | 7581 | |
| 11 | 365 | 4.1% |
| 10 | 236 | 2.6% |
| 9 | 175 | 2.0% |
| 8 | 196 | 2.2% |
| 7 | 190 | 2.1% |
| 6 | 204 | 2.3% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | cust_id | balance | balance_frequency | purchases | oneoff_purchases | installments_purchases | cash_advance | purchases_frequency | oneoff_purchases_frequency | purchases_installments_frequency | cash_advance_frequency | cash_advance_trx | purchases_trx | credit_limit | payments | minimum_payments | prc_full_payment | tenure | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 10001 | 40.900749 | 0.818182 | 95.40 | 0.00 | 95.40 | 0.000000 | 0.166667 | 0.000000 | 0.083333 | 0.000000 | 0 | 2 | 1000.0 | 201.802084 | 139.509787 | 0.000000 | 12 |
| 1 | 1 | 10002 | 3202.467416 | 0.909091 | 0.00 | 0.00 | 0.00 | 6442.945483 | 0.000000 | 0.000000 | 0.000000 | 0.250000 | 4 | 0 | 7000.0 | 4103.032597 | 1072.340217 | 0.222222 | 12 |
| 2 | 2 | 10003 | 2495.148862 | 1.000000 | 773.17 | 773.17 | 0.00 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | 0 | 12 | 7500.0 | 622.066742 | 627.284787 | 0.000000 | 12 |
| 3 | 3 | 10004 | 1666.670542 | 0.636364 | 1499.00 | 1499.00 | 0.00 | 205.788017 | 0.083333 | 0.083333 | 0.000000 | 0.083333 | 1 | 1 | 7500.0 | 0.000000 | 0.000000 | 0.000000 | 12 |
| 4 | 4 | 10005 | 817.714335 | 1.000000 | 16.00 | 16.00 | 0.00 | 0.000000 | 0.083333 | 0.083333 | 0.000000 | 0.000000 | 0 | 1 | 1200.0 | 678.334763 | 244.791237 | 0.000000 | 12 |
| 5 | 5 | 10006 | 1809.828751 | 1.000000 | 1333.28 | 0.00 | 1333.28 | 0.000000 | 0.666667 | 0.000000 | 0.583333 | 0.000000 | 0 | 8 | 1800.0 | 1400.057770 | 2407.246035 | 0.000000 | 12 |
| 6 | 6 | 10007 | 627.260806 | 1.000000 | 7091.01 | 6402.63 | 688.38 | 0.000000 | 1.000000 | 1.000000 | 1.000000 | 0.000000 | 0 | 64 | 13500.0 | 6354.314328 | 198.065894 | 1.000000 | 12 |
| 7 | 7 | 10008 | 1823.652743 | 1.000000 | 436.20 | 0.00 | 436.20 | 0.000000 | 1.000000 | 0.000000 | 1.000000 | 0.000000 | 0 | 12 | 2300.0 | 679.065082 | 532.033990 | 0.000000 | 12 |
| 8 | 8 | 10009 | 1014.926473 | 1.000000 | 861.49 | 661.49 | 200.00 | 0.000000 | 0.333333 | 0.083333 | 0.250000 | 0.000000 | 0 | 5 | 7000.0 | 688.278568 | 311.963409 | 0.000000 | 12 |
| 9 | 9 | 10010 | 152.225975 | 0.545455 | 1281.60 | 1281.60 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 3 | 11000.0 | 1164.770591 | 100.302262 | 0.000000 | 12 |
Last rows
| df_index | cust_id | balance | balance_frequency | purchases | oneoff_purchases | installments_purchases | cash_advance | purchases_frequency | oneoff_purchases_frequency | purchases_installments_frequency | cash_advance_frequency | cash_advance_trx | purchases_trx | credit_limit | payments | minimum_payments | prc_full_payment | tenure | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8937 | 8940 | 19181 | 130.838554 | 1.000000 | 591.24 | 0.00 | 591.24 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 475.523262 | 82.771320 | 1.00 | 6 |
| 8938 | 8941 | 19182 | 5967.475270 | 0.833333 | 214.55 | 0.00 | 214.55 | 8555.409326 | 0.833333 | 0.000000 | 0.666667 | 0.666667 | 13 | 5 | 9000.0 | 966.202912 | 861.949906 | 0.00 | 6 |
| 8939 | 8942 | 19183 | 40.829749 | 1.000000 | 113.28 | 0.00 | 113.28 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 94.488828 | 86.283101 | 0.25 | 6 |
| 8940 | 8943 | 19184 | 5.871712 | 0.500000 | 20.90 | 20.90 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 1 | 500.0 | 58.644883 | 43.473717 | 0.00 | 6 |
| 8941 | 8944 | 19185 | 193.571722 | 0.833333 | 1012.73 | 1012.73 | 0.00 | 0.000000 | 0.333333 | 0.333333 | 0.000000 | 0.000000 | 0 | 2 | 4000.0 | 0.000000 | 0.000000 | 0.00 | 6 |
| 8942 | 8945 | 19186 | 28.493517 | 1.000000 | 291.12 | 0.00 | 291.12 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 325.594462 | 48.886365 | 0.50 | 6 |
| 8943 | 8946 | 19187 | 19.183215 | 1.000000 | 300.00 | 0.00 | 300.00 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 275.861322 | 0.000000 | 0.00 | 6 |
| 8944 | 8947 | 19188 | 23.398673 | 0.833333 | 144.40 | 0.00 | 144.40 | 0.000000 | 0.833333 | 0.000000 | 0.666667 | 0.000000 | 0 | 5 | 1000.0 | 81.270775 | 82.418369 | 0.25 | 6 |
| 8945 | 8948 | 19189 | 13.457564 | 0.833333 | 0.00 | 0.00 | 0.00 | 36.558778 | 0.000000 | 0.000000 | 0.000000 | 0.166667 | 2 | 0 | 500.0 | 52.549959 | 55.755628 | 0.25 | 6 |
| 8946 | 8949 | 19190 | 372.708075 | 0.666667 | 1093.25 | 1093.25 | 0.00 | 127.040008 | 0.666667 | 0.666667 | 0.000000 | 0.333333 | 2 | 23 | 1200.0 | 63.165404 | 88.288956 | 0.00 | 6 |